/* $RCSFile: uninstall.sql $
 Apache license v2 2011 by Christian Surieux
 Removing this comment is forbiddden
 $Source: ?/AddonNice.ImageManager/PageModules/CRMImageBook/uninstall.sql $
 $log$
 Revision 38 2010/08/09 12:28:18  christian.surieux
   Adding Log comment to sql files
*/
/* Uninstall script, Pictures module, manudea 27/10/2003  */

IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID(N'[adn_AddPicture]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
DROP PROCEDURE [adn_AddPicture]
GO

IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID(N'[adn_DeletePicture]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
DROP PROCEDURE [adn_DeletePicture]
GO

IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID(N'[adn_GetPicturesPaged]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
DROP PROCEDURE [adn_GetPicturesPaged]
GO

IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID(N'[adn_GetSinglePicture]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
DROP PROCEDURE [adn_GetSinglePicture]
GO

IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID(N'[adn_UpdatePicture]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
DROP PROCEDURE [adn_UpdatePicture]
GO

IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID(N'[adn_Pictures_stModified]') AND OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [adn_Pictures_stModified]
GO
